Question1: Which of the following can be used when unloading data from Snowflake? (Choose two.)
Question2: What is the MAXIMUM size limit for a record of a VARIANT data type?
Question3: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Question4: Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Question5: How are serverless features billed?
Question6: A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
Question7: What happens when an external or an internal stage is dropped? (Select TWO).
Question8: A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
Question9: Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Question10: To use the overwrite option on insert, which privilege must be granted to the role?
Question11: A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
Question12: Which operation can be performed on Snowflake external tables?
Question13: In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
Question14: What is the MAXIMUM Time Travel retention period for a transient table?
Question15: What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
Question16: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Question17: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Question18: What SQL command would be used to view all roles that were granted to user.1?
Question19: What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Question20: What is the recommended file sizing for data loading using Snowpipe?
Question21: What type of account can be used to share data with a consumer who does have a Snowflake account?
Question22: What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Question23: Which command can be used to list all the file formats for which a user has access privileges?
Question24: Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Question25: When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Question26: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Question27: Which stage type can be altered and dropped?
Question28: What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Question29: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Question30: What privilege should a user be granted to change permissions for new objects in a managed access schema?
Question31: Which REST API can be used with unstructured data?
Question32: What information is found within the Statistic output in the Query Profile Overview?
Question33: Who can activate a network policy for users in a Snowflake account? (Select TWO)
Question34: Which transformation is supported by a COPY INTO <table> command?
Question35: Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
Question36: Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Question37: A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
Question38: What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
Question39: What does the worksheet and database explorer feature in Snowsight allow users to do?
Question40: What does Snowflake recommend regarding database object ownership? (Select TWO).
Question41: While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
Question42: What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Question43: What factors impact storage costs in Snowflake? (Select TWO).
Question44: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
Question45: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Question46: What does Snowflake's search optimization service support?
Question47: In the Data Exchange, who can get or request data from the listings? (Select TWO).
Question48: How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
Question49: What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Question50: Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Question51: Which statement describes how Snowflake supports reader accounts?
Question52: What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)
Question53: Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Question54: When does a materialized view get suspended in Snowflake?
Question55: Which security models are used in Snowflake to manage access control? (Select TWO).
Question56: Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Question57: How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Question58: A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Question59: When is the result set cache no longer available? (Select TWO)
Question60: What COPY INTO SQL command should be used to unload data into multiple files?
Question61: How can a Snowflake user access a JSON object, given the following table? (Select TWO).
Question62: How does Snowflake describe its unique architecture?
Question63: Which access control entity in Snowflake can be created as part of a hierarchy within an account?
Question64: What is cached during a query on a virtual warehouse?
Question65: Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Question66: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Question67: A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
Question68: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Question69: What is the MOST performant file format for loading data in Snowflake?
Question70: Which task is supported by the use of Access History in Snowflake?
Question71: Which Snowflake architectural layer is responsible for a query execution plan?
Question72: A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Question73: In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).
Question74: By default, which Snowflake role is required to create a share?
Question75: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Question76: What happens to historical data when the retention period for an object ends?
Question77: Where can a user find and review the failed logins of a specific user for the past 30 days?
Question78: Which data type can store more than one type of data structure?
Question79: What is the primary purpose of a directory table in Snowflake?
Question80: Which type of role can be granted to a share?
Question81: In which hierarchy is tag inheritance possible?
Question82: While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
Question83: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Question84: The is the minimum Fail-safe retention time period for transient tables?
Question85: Which SQL command can be used to verify the privileges that are granted to a role?
Question86: Which command can be used to list all network policies available in an account?
Question87: What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Question88: Which user preferences can be set for a user profile in Snowsight? (Select TWO).
Question89: What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
Question90: Which Snowflake object can be used to record DML changes made to a table?
Question91: What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
Question92: How often are the Account and Table master keys automatically rotated by Snowflake?
Question93: Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Question94: Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Question95: What can be used to process unstructured data?
Question96: Which privilege is required on a virtual warehouse to abort any existing executing queries?
Question97: How would you determine the size of the virtual warehouse used for a task?
Question98: Which Snowflake object does not consume any storage costs?
Question99: How would a user run a multi-cluster warehouse in maximized mode?
Question100: Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).
Question101: When should a multi-cluster virtual warehouse be used in Snowflake?
Question102: The property mins_to_bypass_network_policy is set at which level?
Question103: What happens when a Snowflake user changes the data retention period at the schema level?
Question104: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Question105: Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Question106: Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?
Question107: What can a Snowflake user do in the Admin area of Snowsight?
Question108: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Question109: How long does Snowflake retain information in the ACCESS HISTORY view?
Question110: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Question111: By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Question112: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Question113: Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
Question114: Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
Question115: Users are responsible for data storage costs until what occurs?
Question116: There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?
Question117: Which role has the ability to create a share from a shared database by default?
Question118: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Question119: Which stream type can be used for tracking the records in external tables?
Question120: How does Snowflake reorganize data when it is loaded? (Select TWO).
Question121: By definition, a secure view is exposed only to users with what privilege?
Question122: Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Question123: Which Snowflow object does not consume and storage costs?
Question124: Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Question125: What are benefits of using Snowpark with Snowflake? (Select TWO).
Question126: What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Question127: Which command will unload data from a table into an external stage?
Question128: Which feature allows a user the ability to control the organization of data in a micro-partition?
Question129: Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
Question130: What information does the Query Profile provide?
Question131: What is the purpose of an External Function?
Question132: Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Question133: Which command can be used to load data into an internal stage?
Question134: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Question135: How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
Question136: How does Snowflake Fail-safe protect data in a permanent table?
Question137: Which of the following commands cannot be used within a reader account?
Question138: Which of the following are characteristics of security in Snowflake?
Question139: What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
Question140: What is true about sharing data in Snowflake? (Choose two.)
Question141: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Question142: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Question143: Which function should be used to insert JSON format string data inot a VARIANT field?
Question144: Which commands can only be executed using SnowSQL? (Select TWO).
Question145: How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Question146: What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Question147: What would cause different results to be returned when running the same query twice?
Question148: Who can create and manage reader accounts? (Select TWO).
Question149: What is the purpose of the Snowflake SPLIT TO_TABLE function?
Question150: What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Question151: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Question152: Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Question153: What is the purpose of multi-cluster virtual warehouses?
Question154: A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
Question155: How many days is load history for Snowpipe retained?
Question156: What transformations are supported when loading data into a table using the COPY INTO <table> command?
(Select TWO).
Question157: Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
Question158: Snowflake's hierarchical key mode includes which keys? (Select TWO).
Question159: A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?
Question160: Which key access control concept does Snowflake descibe as a defined level of access to an object?
Question161: Which privilege must be granted by one role to another role, and cannot be revoked?
Question162: Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?
Question163: Which types of subqueries does Snowflake support? (Select TWO).
Question164: What is the minimum Snowflake edition that has column-level security enabled?
Question165: Which Snowflake layer is associated with virtual warehouses?
Question166: A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
Question167: What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
Question168: Which of the following statements describe features of Snowflake data caching? (Choose two.)
Question169: What causes objects in a data share to become unavailable to a consumer account?
Question170: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Question171: Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?
Question172: A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Question173: What are the benefits of the replication feature in Snowflake? (Select TWO).
Question174: What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Question175: Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Question176: Which URL provides access to files in Snowflake without authorization?
Question177: A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?
Question178: Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Question179: What role is required to use Partner Connect?
Question180: Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
Question181: How can staged files be removed during data loading once the files have loaded successfully?
Question182: What is the relationship between a Query Profile and a virtual warehouse?
Question183: Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Question184: Which Snowflake technique can be used to improve the performance of a query?
Question185: A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
Question186: Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Question187: How can performance be optimized for a query that returns a small amount of data from a very large base table?
Question188: Which of the following objects can be shared through secure data sharing?
Question189: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Question190: What consideration should be made when loading data into Snowflake?
Question191: Which function unloads data from a relational table to JSON?
Question192: At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?
Question193: How does the Access_History view enhance overall data governance pertaining to read and write operations?
(Select TWO).
Question194: Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
Question195: Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Question196: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Question197: Which role has the ability to create and manage users and roles?
Question198: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question199: Which semi-structured file format is a compressed, efficient, columnar data representation?
Question200: While unloading data into a stage, how can the user ensure that the output will be a single file?
Question201: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Question202: A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
Question203: Which file function gives a user or application access to download unstructured data from a Snowflake stage?
Question204: Which object type is granted permissions for reading a table?
Question205: Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Question206: What is the default character set used when loading CSV files into Snowflake?
Question207: How do secure views compare to non-secure views in Snowflake?
Question208: Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).
Question209: What should be considered when deciding to use a secure view? (Select TWO).
Question210: A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Question211: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Question212: Which typos of charts does Snowsight support? (Select TWO).
Question213: Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
Question214: User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
Question215: What is the minimum Snowflake edition required to create a materialized view?
Question216: Why would a Snowflake user decide to use a materialized view instead of a regular view?
Question217: A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
Question218: Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
Question219: What information is stored in the ACCESS_HlSTORY view?
Question220: A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Question221: What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?
Question222: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Question223: What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Question224: If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
Question225: Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Question226: Which Snowflake tool would be BEST to troubleshoot network connectivity?
Question227: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Question228: Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
Question229: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question230: Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)
Question231: If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Question232: Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Question233: Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
Question234: How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Question235: What is a best practice after creating a custom role?
Question236: Which task privilege does a Snowflake role need in order to suspend or resume a task?
Question237: Which view can be used to determine if a table has frequent row updates or deletes?
Question238: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Question239: What column type does a Kafka connector store formatted information in a single column?
Question240: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Question241: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Question242: How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Question243: Which type of workload traditionally benefits from the use of the query acceleration service?
Question244: What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
Question245: Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
Question246: What is a directory table in Snowflake?
Question247: Which pages are included in the Activity area of Snowsight? (Select TWO).
Question248: Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Question249: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question250: Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
Question251: Which minimum Snowflake edition allows for a dedicated metadata store?
Question252: Which of the following describes the Snowflake Cloud Services layer?
Question253: Which Snowflake URL type is used by directory tables?
Question254: If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Question255: In the Snowflake access control model, which entity owns an object by default?
Question256: Which views are included in the data_sharing_usage schema? (Select TWO).
Question257: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Question258: Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
Question259: What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?
Question260: What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Question261: Which function determines the kind of value stored in a VARIANT column?
Question262: Which command is used to remove files from either external cloud storage or an internal staged
Question263: Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Question264: What Snowflake role must be granted for a user to create and manage accounts?
Question265: Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Question266: How can a user get the MOST detailed information about individual table storage details in Snowflake?
Question267: What does a masking policy consist of in Snowflake?
Question268: What type of function returns one value for each Invocation?
Question269: Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
Question270: Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Question271: How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
Question272: When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Question273: Which Snowflake data governance feature can support auditing when a user query reads column data?
Question274: Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Question275: Which of the following SQL statements will list the version of the drivers currently being used?
Question276: Which governance feature is supported by all Snowflake editions?
Question277: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Question278: Which Snowflake database object can be shared with other accounts?
Question279: Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
Question280: True or False: Snowpipe via REST API can only reference External Stages as source.
Question281: Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Question282: A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Question283: Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).
Question284: A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Question285: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
Question286: What command is used to export or unload data from Snowflake?
Question287: What is a key feature of Snowflake architecture?
Question288: Which function will provide the proxy information needed to protect Snowsight?
Question289: A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
Question290: When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?
Question291: Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
Question292: When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Question293: What is used to diagnose and troubleshoot network connections to Snowflake?
Question294: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question295: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question296: Snowflake users can create a resource monitor at which levels? (Select TWO).
Question297: A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
Question298: A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?
Question299: Which Snowflake edition enables data sharing only through Snowflake Support?
Question300: What does the LATERAL modifier for the FLATTEN function do?
Question301: Which type of workload is recommended for Snowpark-optimized virtual warehouses?
Question302: Which TABLE function helps to convert semi-structured data to a relational representation?
Question303: A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?
Question304: For Directory tables, what stage allows for automatic refreshing of metadata?
Question305: What are characteristic of Snowsight worksheet? (Select TWO.)
Question306: Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Question307: Which of the following describes external functions in Snowflake?
Question308: What is the minimum Snowflake edition required for row level security?
Question309: What does a Notify & Suspend action for a resource monitor do?
Question310: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
Question311: What is a characteristic of the Snowflake Query Profile?
Question312: When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Question313: In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities?
(Select TWO).
Question314: What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
Question315: What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Question316: Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
Question317: Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
Question318: Which role is responsible for managing the billing and credit data within Snowflake?
Question319: What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
Question320: Which Snowflake layer is always leveraged when accessing a query from the result cache?
Question321: User-level network policies can be created by which of the following roles? (Select TWO).
Question322: What data is stored in the Snowflake storage layer? (Select TWO).
Question323: Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Question324: The VALIDATE table function has which parameter as an input argument for a Snowflake user?
Question325: What is the MINIMUM permission needed to access a file URL from an external stage?
Question326: How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Question327: Which type of loop requires a BREAK statement to stop executing?
Question328: What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?
Question329: Which Snowflake data type is used to store JSON key value pairs?